System Administration Information
The User Class Access Permissions can be defined by a HighStone Administrator user by clicking on the padlock key to the top left of the Requisitions Panel. This prompts for the Approvals levels:
Raise Record
Confirmed (Submitted) Record
Process Record (Picked Up)
Priced Record
Approve Record
Requisition Record
Cancel Record
The Approval process is supported by the use of System SQL _SQL_REQ_AUTH_SIGNOFF_CHECK (Id 252). This query should return a record if the check is OK. The following is a standard SQL:
SELECT StaffReqAuthId FROM tblStaffReqAuthorities WHERE (SRAStaffId = <REQSTAFFID>) AND (SRAReqClassId = <REQCLASSID>) AND ((SRAAllDepots = <TRUE>) OR (SRAAllDepots = <REQDEPOTID>)) AND (SRAActive = <TRUE>);
The following Operational Configuration is supported. These options are controlled through [tbsSettings] table: Group [System] control for entry RequisitionEntryActions. The entry is a bitwise number based on the following settings. The Default is Zero (following NOT set).
REQ_OPTION_SUPPLIER_NOT_USER (4) - Supplier details NOT editable by general Users
REQ_OPTION_PRICE_NOT_USER (8) - The Item Grid will not show the initial Price Column - so cannot be set.
REQ_OPTION_PRICE_TOTAL_BY_REQ (16) - The Total Price field is calculated from the Requisition Item Cost field, and not the User Entered Price Field.
REQ_OPTION_RETRO_IS_SUPPORTED (2048) - Allow the creation of Retrospective Requisition Records.
Auto Email Requisition on Approved (with copy of Requisition PDF attached) - is controlled through [tbsSettings] table: Group [System] control for entries:
ReqSubmitEmailOption - Numeric value:
0 - No Email Issued (Default option)
1 - User Prompted about sending an Email
2 - Always send an Email
ReqSubmitEmailAddress - The target Email Address
[tblStaffReqAuthorities] - Table that holds the actual User Approvals records.
[ltbRequisitionClass] - The table that lists the Requisition Classes and Authority Levels.
[ltbRequisitionAuthLevel] - A lookup table that lists the priority levels (Primary, Secondary, Third and Fourth).